--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- Name: clientes; Type: SCHEMA; Schema: -; Owner: venetel
--

CREATE SCHEMA clientes;


ALTER SCHEMA clientes OWNER TO venetel;

--
-- Name: operaciones; Type: SCHEMA; Schema: -; Owner: venetel
--

CREATE SCHEMA operaciones;


ALTER SCHEMA operaciones OWNER TO venetel;

--
-- Name: seguridad; Type: SCHEMA; Schema: -; Owner: venetel
--

CREATE SCHEMA seguridad;


ALTER SCHEMA seguridad OWNER TO venetel;

--
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres
--

CREATE PROCEDURAL LANGUAGE plpgsql;


ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres;

SET search_path = clientes, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: clientes; Type: TABLE; Schema: clientes; Owner: venetel; Tablespace: 
--

CREATE TABLE clientes (
    nm_cliente character(50),
    "RIF_cliente" character(15),
    id integer NOT NULL
);


ALTER TABLE clientes.clientes OWNER TO venetel;

--
-- Name: clientes_id_seq; Type: SEQUENCE; Schema: clientes; Owner: venetel
--

CREATE SEQUENCE clientes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE clientes.clientes_id_seq OWNER TO venetel;

--
-- Name: clientes_id_seq; Type: SEQUENCE OWNED BY; Schema: clientes; Owner: venetel
--

ALTER SEQUENCE clientes_id_seq OWNED BY clientes.id;


--
-- Name: clientes_id_seq; Type: SEQUENCE SET; Schema: clientes; Owner: venetel
--

SELECT pg_catalog.setval('clientes_id_seq', 2, true);


--
-- Name: contratos; Type: TABLE; Schema: clientes; Owner: venetel; Tablespace: 
--

CREATE TABLE contratos (
    id integer NOT NULL,
    codigo character(30),
    gerencia_id integer,
    cliente_id integer
);


ALTER TABLE clientes.contratos OWNER TO venetel;

--
-- Name: contratos_id_seq; Type: SEQUENCE; Schema: clientes; Owner: venetel
--

CREATE SEQUENCE contratos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE clientes.contratos_id_seq OWNER TO venetel;

--
-- Name: contratos_id_seq; Type: SEQUENCE OWNED BY; Schema: clientes; Owner: venetel
--

ALTER SEQUENCE contratos_id_seq OWNED BY contratos.id;


--
-- Name: contratos_id_seq; Type: SEQUENCE SET; Schema: clientes; Owner: venetel
--

SELECT pg_catalog.setval('contratos_id_seq', 8, true);


--
-- Name: coordinaciones; Type: TABLE; Schema: clientes; Owner: venetel; Tablespace: 
--

CREATE TABLE coordinaciones (
    nm_coordina character(50),
    id integer NOT NULL
);


ALTER TABLE clientes.coordinaciones OWNER TO venetel;

--
-- Name: coordinaciones_id_seq; Type: SEQUENCE; Schema: clientes; Owner: venetel
--

CREATE SEQUENCE coordinaciones_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE clientes.coordinaciones_id_seq OWNER TO venetel;

--
-- Name: coordinaciones_id_seq; Type: SEQUENCE OWNED BY; Schema: clientes; Owner: venetel
--

ALTER SEQUENCE coordinaciones_id_seq OWNED BY coordinaciones.id;


--
-- Name: coordinaciones_id_seq; Type: SEQUENCE SET; Schema: clientes; Owner: venetel
--

SELECT pg_catalog.setval('coordinaciones_id_seq', 2, true);


--
-- Name: gerencias; Type: TABLE; Schema: clientes; Owner: venetel; Tablespace: 
--

CREATE TABLE gerencias (
    nm_gerencia character(60),
    cliente_id integer,
    id integer NOT NULL
);


ALTER TABLE clientes.gerencias OWNER TO venetel;

--
-- Name: gerencias_id_seq; Type: SEQUENCE; Schema: clientes; Owner: venetel
--

CREATE SEQUENCE gerencias_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE clientes.gerencias_id_seq OWNER TO venetel;

--
-- Name: gerencias_id_seq; Type: SEQUENCE OWNED BY; Schema: clientes; Owner: venetel
--

ALTER SEQUENCE gerencias_id_seq OWNED BY gerencias.id;


--
-- Name: gerencias_id_seq; Type: SEQUENCE SET; Schema: clientes; Owner: venetel
--

SELECT pg_catalog.setval('gerencias_id_seq', 6, true);


--
-- Name: ppgerencias; Type: TABLE; Schema: clientes; Owner: venetel; Tablespace: 
--

CREATE TABLE ppgerencias (
    nm_persona character(60),
    cargo character(60),
    sw_activo boolean,
    gerencia_id integer,
    id integer NOT NULL
);


ALTER TABLE clientes.ppgerencias OWNER TO venetel;

--
-- Name: ppgerencias_id_seq; Type: SEQUENCE; Schema: clientes; Owner: venetel
--

CREATE SEQUENCE ppgerencias_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE clientes.ppgerencias_id_seq OWNER TO venetel;

--
-- Name: ppgerencias_id_seq; Type: SEQUENCE OWNED BY; Schema: clientes; Owner: venetel
--

ALTER SEQUENCE ppgerencias_id_seq OWNED BY ppgerencias.id;


--
-- Name: ppgerencias_id_seq; Type: SEQUENCE SET; Schema: clientes; Owner: venetel
--

SELECT pg_catalog.setval('ppgerencias_id_seq', 2, true);


SET search_path = operaciones, pg_catalog;

--
-- Name: actas; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE actas (
    id integer NOT NULL,
    coordinacione_id integer,
    proyecto_id integer,
    fl_acta character(12)
);


ALTER TABLE operaciones.actas OWNER TO venetel;

--
-- Name: actas_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE actas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.actas_id_seq OWNER TO venetel;

--
-- Name: actas_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE actas_id_seq OWNED BY actas.id;


--
-- Name: actas_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('actas_id_seq', 1, true);


--
-- Name: entregables; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE entregables (
    id integer NOT NULL,
    servicio_id integer,
    nm_entregable character(90),
    descrip text
);


ALTER TABLE operaciones.entregables OWNER TO venetel;

--
-- Name: entregables_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE entregables_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.entregables_id_seq OWNER TO venetel;

--
-- Name: entregables_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE entregables_id_seq OWNED BY entregables.id;


--
-- Name: entregables_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('entregables_id_seq', 9, true);


--
-- Name: ordenes; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE ordenes (
    id integer NOT NULL,
    nu_orden numeric,
    solpa numeric,
    nu_aceptacion_sap numeric,
    fl_libera character(12),
    proyecto_id integer
);


ALTER TABLE operaciones.ordenes OWNER TO venetel;

--
-- Name: ordenes_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE ordenes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.ordenes_id_seq OWNER TO venetel;

--
-- Name: ordenes_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE ordenes_id_seq OWNED BY ordenes.id;


--
-- Name: ordenes_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('ordenes_id_seq', 2, true);


--
-- Name: precios; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE precios (
    id integer NOT NULL,
    servicio_id integer,
    fl_actualiza character(12),
    precio double precision,
    entregable_id numeric
);


ALTER TABLE operaciones.precios OWNER TO venetel;

--
-- Name: precios_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE precios_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.precios_id_seq OWNER TO venetel;

--
-- Name: precios_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE precios_id_seq OWNED BY precios.id;


--
-- Name: precios_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('precios_id_seq', 4, true);


--
-- Name: proyectos; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE proyectos (
    id integer NOT NULL,
    ppgerencia_id integer,
    gerencia_id integer,
    nm_proyecto character(90),
    coordinacion character(90)
);


ALTER TABLE operaciones.proyectos OWNER TO venetel;

--
-- Name: proyectos_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE proyectos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.proyectos_id_seq OWNER TO venetel;

--
-- Name: proyectos_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE proyectos_id_seq OWNED BY proyectos.id;


--
-- Name: proyectos_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('proyectos_id_seq', 2, true);


--
-- Name: servordenes; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE servordenes (
    id integer NOT NULL,
    ordene_id integer,
    servicio_id integer,
    posicion integer,
    cantidad numeric
);


ALTER TABLE operaciones.servordenes OWNER TO venetel;

--
-- Name: serv_ordenes_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE serv_ordenes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.serv_ordenes_id_seq OWNER TO venetel;

--
-- Name: serv_ordenes_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE serv_ordenes_id_seq OWNED BY servordenes.id;


--
-- Name: serv_ordenes_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('serv_ordenes_id_seq', 4, true);


--
-- Name: servicios; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE servicios (
    nm_servicio character(90),
    id integer NOT NULL
);


ALTER TABLE operaciones.servicios OWNER TO venetel;

--
-- Name: servicios_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE servicios_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.servicios_id_seq OWNER TO venetel;

--
-- Name: servicios_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE servicios_id_seq OWNED BY servicios.id;


--
-- Name: servicios_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('servicios_id_seq', 8, true);


--
-- Name: servrealizados; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE servrealizados (
    id integer NOT NULL,
    coordinacione_id integer,
    proyecto_id integer,
    ordene_id integer,
    acta_id integer,
    ppgerencia_id integer,
    persona_id integer,
    cantidad numeric,
    descripcion character(150),
    fl_incio character(12),
    fl_fin character(12),
    posicion integer
);


ALTER TABLE operaciones.servrealizados OWNER TO venetel;

--
-- Name: servrealizados_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE servrealizados_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.servrealizados_id_seq OWNER TO venetel;

--
-- Name: servrealizados_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE servrealizados_id_seq OWNED BY servrealizados.id;


--
-- Name: servrealizados_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('servrealizados_id_seq', 2, true);


--
-- Name: textos; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE textos (
    id integer NOT NULL,
    entregable_id integer,
    descripcion character(200)
);


ALTER TABLE operaciones.textos OWNER TO venetel;

--
-- Name: texto_entregables_id_seq; Type: SEQUENCE; Schema: operaciones; Owner: venetel
--

CREATE SEQUENCE texto_entregables_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE operaciones.texto_entregables_id_seq OWNER TO venetel;

--
-- Name: texto_entregables_id_seq; Type: SEQUENCE OWNED BY; Schema: operaciones; Owner: venetel
--

ALTER SEQUENCE texto_entregables_id_seq OWNED BY textos.id;


--
-- Name: texto_entregables_id_seq; Type: SEQUENCE SET; Schema: operaciones; Owner: venetel
--

SELECT pg_catalog.setval('texto_entregables_id_seq', 2, true);


--
-- Name: textoactas; Type: TABLE; Schema: operaciones; Owner: venetel; Tablespace: 
--

CREATE TABLE textoactas (
    id integer DEFAULT nextval('texto_entregables_id_seq'::regclass) NOT NULL,
    acta_id integer,
    descripcion character(200)
);


ALTER TABLE operaciones.textoactas OWNER TO venetel;

SET search_path = public, pg_catalog;

--
-- Name: acos; Type: TABLE; Schema: public; Owner: venetel; Tablespace: 
--

CREATE TABLE acos (
    id integer NOT NULL,
    parent_id integer,
    model character varying(255) DEFAULT NULL::character varying,
    foreign_key integer,
    alias character varying(255) DEFAULT NULL::character varying,
    lft integer,
    rght integer
);


ALTER TABLE public.acos OWNER TO venetel;

--
-- Name: acos_id_seq; Type: SEQUENCE; Schema: public; Owner: venetel
--

CREATE SEQUENCE acos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.acos_id_seq OWNER TO venetel;

--
-- Name: acos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: venetel
--

ALTER SEQUENCE acos_id_seq OWNED BY acos.id;


--
-- Name: acos_id_seq; Type: SEQUENCE SET; Schema: public; Owner: venetel
--

SELECT pg_catalog.setval('acos_id_seq', 1, false);


--
-- Name: aros; Type: TABLE; Schema: public; Owner: venetel; Tablespace: 
--

CREATE TABLE aros (
    id integer NOT NULL,
    parent_id integer,
    model character varying(255) DEFAULT NULL::character varying,
    foreign_key integer,
    alias character varying(255) DEFAULT NULL::character varying,
    lft integer,
    rght integer
);


ALTER TABLE public.aros OWNER TO venetel;

--
-- Name: aros_acos; Type: TABLE; Schema: public; Owner: venetel; Tablespace: 
--

CREATE TABLE aros_acos (
    id integer NOT NULL,
    aro_id integer NOT NULL,
    aco_id integer NOT NULL,
    _create character varying(2) DEFAULT '0'::character varying NOT NULL,
    _read character varying(2) DEFAULT '0'::character varying NOT NULL,
    _update character varying(2) DEFAULT '0'::character varying NOT NULL,
    _delete character varying(2) DEFAULT '0'::character varying NOT NULL
);


ALTER TABLE public.aros_acos OWNER TO venetel;

--
-- Name: aros_acos_id_seq; Type: SEQUENCE; Schema: public; Owner: venetel
--

CREATE SEQUENCE aros_acos_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.aros_acos_id_seq OWNER TO venetel;

--
-- Name: aros_acos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: venetel
--

ALTER SEQUENCE aros_acos_id_seq OWNED BY aros_acos.id;


--
-- Name: aros_acos_id_seq; Type: SEQUENCE SET; Schema: public; Owner: venetel
--

SELECT pg_catalog.setval('aros_acos_id_seq', 1, false);


--
-- Name: aros_id_seq; Type: SEQUENCE; Schema: public; Owner: venetel
--

CREATE SEQUENCE aros_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.aros_id_seq OWNER TO venetel;

--
-- Name: aros_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: venetel
--

ALTER SEQUENCE aros_id_seq OWNED BY aros.id;


--
-- Name: aros_id_seq; Type: SEQUENCE SET; Schema: public; Owner: venetel
--

SELECT pg_catalog.setval('aros_id_seq', 1, true);


SET search_path = seguridad, pg_catalog;

--
-- Name: funciones; Type: TABLE; Schema: seguridad; Owner: venetel; Tablespace: 
--

CREATE TABLE funciones (
    descripcion character(40),
    cod_funcion character(6),
    id integer NOT NULL
);


ALTER TABLE seguridad.funciones OWNER TO venetel;

--
-- Name: funciones_id_seq; Type: SEQUENCE; Schema: seguridad; Owner: venetel
--

CREATE SEQUENCE funciones_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE seguridad.funciones_id_seq OWNER TO venetel;

--
-- Name: funciones_id_seq; Type: SEQUENCE OWNED BY; Schema: seguridad; Owner: venetel
--

ALTER SEQUENCE funciones_id_seq OWNED BY funciones.id;


--
-- Name: funciones_id_seq; Type: SEQUENCE SET; Schema: seguridad; Owner: venetel
--

SELECT pg_catalog.setval('funciones_id_seq', 1, false);


--
-- Name: funciones_roles; Type: TABLE; Schema: seguridad; Owner: venetel; Tablespace: 
--

CREATE TABLE funciones_roles (
    id integer NOT NULL,
    funcion_id numeric,
    rol_id numeric
);


ALTER TABLE seguridad.funciones_roles OWNER TO venetel;

--
-- Name: funciones_roles_id_seq; Type: SEQUENCE; Schema: seguridad; Owner: venetel
--

CREATE SEQUENCE funciones_roles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE seguridad.funciones_roles_id_seq OWNER TO venetel;

--
-- Name: funciones_roles_id_seq; Type: SEQUENCE OWNED BY; Schema: seguridad; Owner: venetel
--

ALTER SEQUENCE funciones_roles_id_seq OWNED BY funciones_roles.id;


--
-- Name: funciones_roles_id_seq; Type: SEQUENCE SET; Schema: seguridad; Owner: venetel
--

SELECT pg_catalog.setval('funciones_roles_id_seq', 1, false);


--
-- Name: personas; Type: TABLE; Schema: seguridad; Owner: venetel; Tablespace: 
--

CREATE TABLE personas (
    id integer NOT NULL,
    nombres character(30),
    apellidos character(30),
    cedula integer,
    rif character(20),
    telefono numeric,
    correo character(40),
    fl_ingreso character(10),
    fl_egreso character(10),
    fecha_nacimiento character(10),
    razon_social character(30),
    sw_activo boolean DEFAULT true,
    salario numeric,
    telefono_movil character(12),
    cooperativa character(60),
    sw_tipo numeric,
    correo2 character(40),
    correo3 character(40),
    nro_cert integer
);


ALTER TABLE seguridad.personas OWNER TO venetel;

--
-- Name: personas_id_seq; Type: SEQUENCE; Schema: seguridad; Owner: venetel
--

CREATE SEQUENCE personas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE seguridad.personas_id_seq OWNER TO venetel;

--
-- Name: personas_id_seq; Type: SEQUENCE OWNED BY; Schema: seguridad; Owner: venetel
--

ALTER SEQUENCE personas_id_seq OWNED BY personas.id;


--
-- Name: personas_id_seq; Type: SEQUENCE SET; Schema: seguridad; Owner: venetel
--

SELECT pg_catalog.setval('personas_id_seq', 15, true);


--
-- Name: roles; Type: TABLE; Schema: seguridad; Owner: venetel; Tablespace: 
--

CREATE TABLE roles (
    id integer NOT NULL,
    nombre character(30)
);


ALTER TABLE seguridad.roles OWNER TO venetel;

--
-- Name: roles_id_seq; Type: SEQUENCE; Schema: seguridad; Owner: venetel
--

CREATE SEQUENCE roles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE seguridad.roles_id_seq OWNER TO venetel;

--
-- Name: roles_id_seq; Type: SEQUENCE OWNED BY; Schema: seguridad; Owner: venetel
--

ALTER SEQUENCE roles_id_seq OWNED BY roles.id;


--
-- Name: roles_id_seq; Type: SEQUENCE SET; Schema: seguridad; Owner: venetel
--

SELECT pg_catalog.setval('roles_id_seq', 3, true);


--
-- Name: salarios; Type: TABLE; Schema: seguridad; Owner: venetel; Tablespace: 
--

CREATE TABLE salarios (
    id integer NOT NULL,
    persona_id integer,
    fl_actualiza character(12),
    mt_salario numeric,
    bn_vacaciones numeric,
    utilidades numeric,
    vacaciones numeric,
    bn_celular numeric,
    pr_experiencia numeric,
    bn_alimentacion numeric,
    educacion numeric,
    bn_estaciona numeric
);


ALTER TABLE seguridad.salarios OWNER TO venetel;

--
-- Name: salarios_id_seq; Type: SEQUENCE; Schema: seguridad; Owner: venetel
--

CREATE SEQUENCE salarios_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE seguridad.salarios_id_seq OWNER TO venetel;

--
-- Name: salarios_id_seq; Type: SEQUENCE OWNED BY; Schema: seguridad; Owner: venetel
--

ALTER SEQUENCE salarios_id_seq OWNED BY salarios.id;


--
-- Name: salarios_id_seq; Type: SEQUENCE SET; Schema: seguridad; Owner: venetel
--

SELECT pg_catalog.setval('salarios_id_seq', 5, true);


--
-- Name: usuarios; Type: TABLE; Schema: seguridad; Owner: venetel; Tablespace: 
--

CREATE TABLE usuarios (
    id integer NOT NULL,
    usuario character(30),
    clave character(50),
    persona_id integer,
    sw_activo boolean DEFAULT true,
    rol_id integer
);


ALTER TABLE seguridad.usuarios OWNER TO venetel;

--
-- Name: usuarios_id_seq; Type: SEQUENCE; Schema: seguridad; Owner: venetel
--

CREATE SEQUENCE usuarios_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE seguridad.usuarios_id_seq OWNER TO venetel;

--
-- Name: usuarios_id_seq; Type: SEQUENCE OWNED BY; Schema: seguridad; Owner: venetel
--

ALTER SEQUENCE usuarios_id_seq OWNED BY usuarios.id;


--
-- Name: usuarios_id_seq; Type: SEQUENCE SET; Schema: seguridad; Owner: venetel
--

SELECT pg_catalog.setval('usuarios_id_seq', 16, true);


SET search_path = clientes, pg_catalog;

--
-- Name: id; Type: DEFAULT; Schema: clientes; Owner: venetel
--

ALTER TABLE clientes ALTER COLUMN id SET DEFAULT nextval('clientes_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: clientes; Owner: venetel
--

ALTER TABLE contratos ALTER COLUMN id SET DEFAULT nextval('contratos_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: clientes; Owner: venetel
--

ALTER TABLE coordinaciones ALTER COLUMN id SET DEFAULT nextval('coordinaciones_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: clientes; Owner: venetel
--

ALTER TABLE gerencias ALTER COLUMN id SET DEFAULT nextval('gerencias_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: clientes; Owner: venetel
--

ALTER TABLE ppgerencias ALTER COLUMN id SET DEFAULT nextval('ppgerencias_id_seq'::regclass);


SET search_path = operaciones, pg_catalog;

--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE actas ALTER COLUMN id SET DEFAULT nextval('actas_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE entregables ALTER COLUMN id SET DEFAULT nextval('entregables_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE ordenes ALTER COLUMN id SET DEFAULT nextval('ordenes_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE precios ALTER COLUMN id SET DEFAULT nextval('precios_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE proyectos ALTER COLUMN id SET DEFAULT nextval('proyectos_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE servicios ALTER COLUMN id SET DEFAULT nextval('servicios_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE servordenes ALTER COLUMN id SET DEFAULT nextval('serv_ordenes_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE servrealizados ALTER COLUMN id SET DEFAULT nextval('servrealizados_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: operaciones; Owner: venetel
--

ALTER TABLE textos ALTER COLUMN id SET DEFAULT nextval('texto_entregables_id_seq'::regclass);


SET search_path = public, pg_catalog;

--
-- Name: id; Type: DEFAULT; Schema: public; Owner: venetel
--

ALTER TABLE acos ALTER COLUMN id SET DEFAULT nextval('acos_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: venetel
--

ALTER TABLE aros ALTER COLUMN id SET DEFAULT nextval('aros_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: venetel
--

ALTER TABLE aros_acos ALTER COLUMN id SET DEFAULT nextval('aros_acos_id_seq'::regclass);


SET search_path = seguridad, pg_catalog;

--
-- Name: id; Type: DEFAULT; Schema: seguridad; Owner: venetel
--

ALTER TABLE funciones ALTER COLUMN id SET DEFAULT nextval('funciones_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: seguridad; Owner: venetel
--

ALTER TABLE funciones_roles ALTER COLUMN id SET DEFAULT nextval('funciones_roles_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: seguridad; Owner: venetel
--

ALTER TABLE personas ALTER COLUMN id SET DEFAULT nextval('personas_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: seguridad; Owner: venetel
--

ALTER TABLE roles ALTER COLUMN id SET DEFAULT nextval('roles_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: seguridad; Owner: venetel
--

ALTER TABLE salarios ALTER COLUMN id SET DEFAULT nextval('salarios_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: seguridad; Owner: venetel
--

ALTER TABLE usuarios ALTER COLUMN id SET DEFAULT nextval('usuarios_id_seq'::regclass);


SET search_path = clientes, pg_catalog;

--
-- Data for Name: clientes; Type: TABLE DATA; Schema: clientes; Owner: venetel
--

COPY clientes (nm_cliente, "RIF_cliente", id) FROM stdin;
CANTV                                             	J-30001203-1   	1
Movilnet                                          	G-20001342-1   	2
\.


--
-- Data for Name: contratos; Type: TABLE DATA; Schema: clientes; Owner: venetel
--

COPY contratos (id, codigo, gerencia_id, cliente_id) FROM stdin;
1	contrato                      	1	1
2	cv-120-aabbbxw                	1	1
3	contrato-1                    	1	1
4	contrato-movilnet             	2	2
5	123445                        	\N	1
6	cv100000-13                   	\N	1
7	cv-120-aabbbxw                	\N	2
8	123                           	3	2
\.


--
-- Data for Name: coordinaciones; Type: TABLE DATA; Schema: clientes; Owner: venetel
--

COPY coordinaciones (nm_coordina, id) FROM stdin;
Ingenieria                                        	1
Construccion                                      	2
\.


--
-- Data for Name: gerencias; Type: TABLE DATA; Schema: clientes; Owner: venetel
--

COPY gerencias (nm_gerencia, cliente_id, id) FROM stdin;
Aplicaciones Modulares                                      	1	1
Tecnologia                                                  	2	2
Gcia. Redes de Telecomunicaciones                           	2	3
Gcia. de la Calidad                                         	1	5
Administracion                                              	1	6
\.


--
-- Data for Name: ppgerencias; Type: TABLE DATA; Schema: clientes; Owner: venetel
--

COPY ppgerencias (nm_persona, cargo, sw_activo, gerencia_id, id) FROM stdin;
Jose Perez                                                  	Gerente de tecnologia                                       	t	2	1
Pedro Bonillo                                               	Gerente                                                     	t	6	2
\.


SET search_path = operaciones, pg_catalog;

--
-- Data for Name: actas; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY actas (id, coordinacione_id, proyecto_id, fl_acta) FROM stdin;
1	1	1	12/01/2010  
\.


--
-- Data for Name: entregables; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY entregables (id, servicio_id, nm_entregable, descrip) FROM stdin;
2	3	determinacion de origen de la falla                                                       	\N
4	5	Soporte tecnico de ejecucion de proyectos                                                 	\N
5	8	Ingenieria de Detalle                                                                     	\N
6	8	Revision                                                                                  	\N
7	3	Reparacion de la Falla                                                                    	\N
8	2	Ingenieria de Detalle                                                                     	123\r\n456\r\n789
9	2	123                                                                                       	<ul><li>caracas</li><li>pedro<br></li></ul>
1	3	revision                                                                                  	<ol><li>caracas</li><li>coro</li><li>san juan<br></li></ol>
3	3	Reparacion de la Falla                                                                    	caracas<br><ol><li><i>coro</i></li><li><b>pto fijo</b><br></li></ol>
\.


--
-- Data for Name: ordenes; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY ordenes (id, nu_orden, solpa, nu_aceptacion_sap, fl_libera, proyecto_id) FROM stdin;
1	5200163373	373	50000932238	25/11/2011  	1
2	52345678	456899	54321	11/01/2011  	2
\.


--
-- Data for Name: precios; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY precios (id, servicio_id, fl_actualiza, precio, entregable_id) FROM stdin;
4	8	03/01/2011  	1000	1
3	3	01/12/2010  	1000	3
1	2	12/11/2010  	1500	4
\.


--
-- Data for Name: proyectos; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY proyectos (id, ppgerencia_id, gerencia_id, nm_proyecto, coordinacion) FROM stdin;
1	1	2	Interconexion 2011                                                                        	Seguimiento                                                                               
2	2	2	Altas Velocidades                                                                         	Construccion                                                                              
\.


--
-- Data for Name: servicios; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY servicios (nm_servicio, id) FROM stdin;
Informe Periodico de Seguimiento de Actividades Tecnicas alertas y deviaciones            	2
Reparacion de equipos                                                                     	3
Soporte Tecnico de Ejecucion de Proyectos para el seguimiento financiero de los proyectos 	5
Soporte Tecnico de Ejecucion de Proyectos para incios de procesos de puntos de cuenta     	6
Soporte Tecnico de Ejecucion de Proyectos para seguimiento de procesos de puntos de cuenta	7
Ingenieria de Detalle                                                                     	8
\.


--
-- Data for Name: servordenes; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY servordenes (id, ordene_id, servicio_id, posicion, cantidad) FROM stdin;
1	1	5	10	3
2	1	6	20	1
3	1	2	30	4
4	2	3	10	2
\.


--
-- Data for Name: servrealizados; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY servrealizados (id, coordinacione_id, proyecto_id, ordene_id, acta_id, ppgerencia_id, persona_id, cantidad, descripcion, fl_incio, fl_fin, posicion) FROM stdin;
1	1	1	1	0	1	12	2	prueba de esto                                                                                                                                        	12/01/2010  	27/01/2010  	\N
2	1	1	1	0	1	13	2	xxxxx                                                                                                                                                 	12/01/2010  	27/01/2010  	20
\.


--
-- Data for Name: textoactas; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY textoactas (id, acta_id, descripcion) FROM stdin;
\.


--
-- Data for Name: textos; Type: TABLE DATA; Schema: operaciones; Owner: venetel
--

COPY textos (id, entregable_id, descripcion) FROM stdin;
1	4	1) Levantamiento de Informacion                                                                                                                                                                         
2	1	prueba de esto                                                                                                                                                                                          
\.


SET search_path = public, pg_catalog;

--
-- Data for Name: acos; Type: TABLE DATA; Schema: public; Owner: venetel
--

COPY acos (id, parent_id, model, foreign_key, alias, lft, rght) FROM stdin;
\.


--
-- Data for Name: aros; Type: TABLE DATA; Schema: public; Owner: venetel
--

COPY aros (id, parent_id, model, foreign_key, alias, lft, rght) FROM stdin;
1	\N	Usuario	16	\N	1	2
\.


--
-- Data for Name: aros_acos; Type: TABLE DATA; Schema: public; Owner: venetel
--

COPY aros_acos (id, aro_id, aco_id, _create, _read, _update, _delete) FROM stdin;
\.


SET search_path = seguridad, pg_catalog;

--
-- Data for Name: funciones; Type: TABLE DATA; Schema: seguridad; Owner: venetel
--

COPY funciones (descripcion, cod_funcion, id) FROM stdin;
\.


--
-- Data for Name: funciones_roles; Type: TABLE DATA; Schema: seguridad; Owner: venetel
--

COPY funciones_roles (id, funcion_id, rol_id) FROM stdin;
\.


--
-- Data for Name: personas; Type: TABLE DATA; Schema: seguridad; Owner: venetel
--

COPY personas (id, nombres, apellidos, cedula, rif, telefono, correo, fl_ingreso, fl_egreso, fecha_nacimiento, razon_social, sw_activo, salario, telefono_movil, cooperativa, sw_tipo, correo2, correo3, nro_cert) FROM stdin;
12	Andres                        	Garcia                        	16877956	V-16877956-4        	2122513555	alvar0@gm.com                           	03/01/2011	03/01/2011	31/01/2011	\N	t	\N	04142905804 	\N	1	\N	\N	\N
13	Milagros                      	Pedroza                       	12671810	V-12671810          	2122513555	al@gm.com                               	11/01/2011	04/01/2011	04/01/2011	\N	t	9000	04142905804 	\N	1	al1@gm.com                              	al2@gm.com                              	\N
14	Jessenia                      	Tejada Pedroza                	16877956	V-16877956-4        	2122513555	javi@venetel.com                        	10/01/2011	25/01/2011	24/01/2011	12                            	t	7500	04142905804 	\N	3	al1@gm.com                              	al2@gm.com                              	3
15	miguelangel                   	cabrera                       	16075549	V-16075549-7        	2122513555	migue@migue.com                         	01/03/2011	03/03/2011	01/03/2011	S/N                           	t	9000	04142905804 	\N	\N	al1@gm.com                              	al2@gm.com                              	\N
\.


--
-- Data for Name: roles; Type: TABLE DATA; Schema: seguridad; Owner: venetel
--

COPY roles (id, nombre) FROM stdin;
1	Superusuario                  
2	Administrador                 
3	Consulta                      
\.


--
-- Data for Name: salarios; Type: TABLE DATA; Schema: seguridad; Owner: venetel
--

COPY salarios (id, persona_id, fl_actualiza, mt_salario, bn_vacaciones, utilidades, vacaciones, bn_celular, pr_experiencia, bn_alimentacion, educacion, bn_estaciona) FROM stdin;
1	14	01/01/2011  	4550	2000	9000	3000	250	230	700	2000	220
\.


--
-- Data for Name: usuarios; Type: TABLE DATA; Schema: seguridad; Owner: venetel
--

COPY usuarios (id, usuario, clave, persona_id, sw_activo, rol_id) FROM stdin;
1	cristina                      	1234                                              	\N	t	\N
2	miguel4ngel                   	1234                                              	\N	t	\N
4	jolivieri                     	16599404                                          	3	t	\N
3	miguel4ngel                   	ea398ef10bd14fd24dc2b5cf3e0547df2c3081b7          	2	t	\N
5	admin                         	cecf8a2a1e7be17d29dc0c8df563a03e28a9ea1b          	4	t	\N
6	ftupa                         	00671d5f22548f2d07407520deac63d02c585add          	5	t	\N
7	ftupa                         	a33f7003bd3daf39e03d78ccd3cdb39ec30cbc7b          	6	t	\N
8	prueba                        	a7c8b97f544a0802d633ff3e02bb62d84fd776eb          	7	t	\N
9	azaval                        	dd270d96059a4d3d5bba002b1a8f03319400e174          	8	t	\N
10	\N	\N	9	t	\N
11	\N	\N	10	t	\N
12	\N	\N	11	t	\N
13	\N	\N	12	t	\N
14	\N	\N	13	t	\N
15	                              	39409726a8ca8dc1a4141030b70686a77e702957          	14	t	\N
16	miguel4ngel                   	5d1fef0153577509ce5a407a40691c12d9a96d29          	15	t	1
\.


SET search_path = clientes, pg_catalog;

--
-- Name: clientes_pkey; Type: CONSTRAINT; Schema: clientes; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY clientes
    ADD CONSTRAINT clientes_pkey PRIMARY KEY (id);


--
-- Name: contratos_pkey; Type: CONSTRAINT; Schema: clientes; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY contratos
    ADD CONSTRAINT contratos_pkey PRIMARY KEY (id);


--
-- Name: cordinaciones_pkey; Type: CONSTRAINT; Schema: clientes; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY coordinaciones
    ADD CONSTRAINT cordinaciones_pkey PRIMARY KEY (id);


--
-- Name: gerencias_pkey; Type: CONSTRAINT; Schema: clientes; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY gerencias
    ADD CONSTRAINT gerencias_pkey PRIMARY KEY (id);


--
-- Name: ppgerencias_pkey; Type: CONSTRAINT; Schema: clientes; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY ppgerencias
    ADD CONSTRAINT ppgerencias_pkey PRIMARY KEY (id);


SET search_path = operaciones, pg_catalog;

--
-- Name: actas_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY actas
    ADD CONSTRAINT actas_pkey PRIMARY KEY (id);


--
-- Name: entregables_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY entregables
    ADD CONSTRAINT entregables_pkey PRIMARY KEY (id);


--
-- Name: ordenes_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY ordenes
    ADD CONSTRAINT ordenes_pkey PRIMARY KEY (id);


--
-- Name: precios_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY precios
    ADD CONSTRAINT precios_pkey PRIMARY KEY (id);


--
-- Name: proyectos_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY proyectos
    ADD CONSTRAINT proyectos_pkey PRIMARY KEY (id);


--
-- Name: serv_ordenes_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY servordenes
    ADD CONSTRAINT serv_ordenes_pkey PRIMARY KEY (id);


--
-- Name: servicios_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY servicios
    ADD CONSTRAINT servicios_pkey PRIMARY KEY (id);


--
-- Name: servrealizados_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY servrealizados
    ADD CONSTRAINT servrealizados_pkey PRIMARY KEY (id);


--
-- Name: texto_entregables_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY textos
    ADD CONSTRAINT texto_entregables_pkey PRIMARY KEY (id);


--
-- Name: textoactas_pkey; Type: CONSTRAINT; Schema: operaciones; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY textoactas
    ADD CONSTRAINT textoactas_pkey PRIMARY KEY (id);


SET search_path = public, pg_catalog;

--
-- Name: acos_pkey; Type: CONSTRAINT; Schema: public; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY acos
    ADD CONSTRAINT acos_pkey PRIMARY KEY (id);


--
-- Name: aros_acos_pkey; Type: CONSTRAINT; Schema: public; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY aros_acos
    ADD CONSTRAINT aros_acos_pkey PRIMARY KEY (id);


--
-- Name: aros_pkey; Type: CONSTRAINT; Schema: public; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY aros
    ADD CONSTRAINT aros_pkey PRIMARY KEY (id);


SET search_path = seguridad, pg_catalog;

--
-- Name: funciones_pkey; Type: CONSTRAINT; Schema: seguridad; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY funciones
    ADD CONSTRAINT funciones_pkey PRIMARY KEY (id);


--
-- Name: funciones_roles_pkey; Type: CONSTRAINT; Schema: seguridad; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY funciones_roles
    ADD CONSTRAINT funciones_roles_pkey PRIMARY KEY (id);


--
-- Name: personas_pkey; Type: CONSTRAINT; Schema: seguridad; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY personas
    ADD CONSTRAINT personas_pkey PRIMARY KEY (id);


--
-- Name: roles_pkey; Type: CONSTRAINT; Schema: seguridad; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY roles
    ADD CONSTRAINT roles_pkey PRIMARY KEY (id);


--
-- Name: salarios_pkey; Type: CONSTRAINT; Schema: seguridad; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY salarios
    ADD CONSTRAINT salarios_pkey PRIMARY KEY (id);


--
-- Name: usuarios_pkey; Type: CONSTRAINT; Schema: seguridad; Owner: venetel; Tablespace: 
--

ALTER TABLE ONLY usuarios
    ADD CONSTRAINT usuarios_pkey PRIMARY KEY (id);


SET search_path = public, pg_catalog;

--
-- Name: aro_aco_key; Type: INDEX; Schema: public; Owner: venetel; Tablespace: 
--

CREATE UNIQUE INDEX aro_aco_key ON aros_acos USING btree (aro_id, aco_id);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--

